create external table jms_ods.tab_report_errorseparatedetail 
(  scan_time          timestamp   comment'日期',
   site_code          string      comment'网点编号',
   site_name          string      comment'网点名称',
   proxy_area_code    string      comment'代理区编号',
   proxy_area_name    string      comment'代理区名称',
   billcode           string      comment'单号',
   next_site          string      comment'发件下一站',
   scanuser           string      comment'发件扫描员',
   distribution_name  string      comment'派送集散点',
   sign_network_name  string      comment'签收网点',
   errorseparate_type string      comment'错分类型',
   remark1            string      comment'',
   remark2            string      comment'',
   create_time        timestamp   comment'创建日期'
)comment '中心错分明细切片'
PARTITIONED BY ( `dt` string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_ods.db/external/tab_report_errorseparatedetail'
TBLPROPERTIES (
    'discover.partitions' = 'false',  -- 禁止 hive 自动发现分区
    'parquet.column.index.access' = 'true');